Duplicate Report In Report Engine Fix
| Document Version | v.2 |
|---|---|
| Document Last Updated | 2/3/2020 |
| Software Version Documented | v.9.5.83 |
Duplicate Report in Report Engine Fix
This document will show you how to fix duplicate reports showing up in the Report Engine.
Delete duplicate reports in SQL
-
Run a SQL query to delete all affected reports where ReportModSys = the duplicate report
- Delete from ReportMod Where ReportModSys = 120 OR ReportModSys = 100133
Open affected reports .SER file in notepad
-
Copy all contents to a new query window
-
Then Execute the query which will rebuild the report and remove the duplicate entries.